package com.kmt.plaza.dao;

import com.kmt.plaza.entity.Product;
import com.kmt.plaza.entity.ProductSku;
import com.kmt.plaza.general.GeneralDAO;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ProductSkuMapper extends GeneralDAO<ProductSku> {
    /**
     * 根据商品ID，查询当前商品所有套餐中价格最低的套餐
     * @param productId
     * @return
     */
    public List<ProductSku> selectLowerestPriceByProductId(String productId);
    /**
     * 管理员查询库存紧张的商品
     */
    public List<ProductSku> selectInventoryShortage();
    //增加商品规格
    public int insertProductSku(ProductSku productSku);
    public int updateProductSku(ProductSku productSku);
}